<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="Viewing MySQL/MariaDB/GreatSQL Database Environment Information">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="mysql-0077.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
  <meta name="DC.Publisher" content="20241029">
  <meta name="documenttype" content="usermanual">
  <meta name="prodname" content="csbs">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="mysql-0078">
  <meta name="DC.Language" content="en-us">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>Viewing MySQL/MariaDB/GreatSQL Database Environment Information</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="mysql-0078"></a><a name="mysql-0078"></a>
  <h1 class="topictitle1">Viewing MySQL/MariaDB/GreatSQL Database Environment Information</h1>
  <div>
   <p>After a MySQL/MariaDB/GreatSQL database is registered with the <span>product</span>, you can view details about the databases, clusters, and instances on the management page.</p>
   <div class="section">
    <h4 class="sectiontitle">Procedure</h4>
    <ol>
     <li><span>Choose <span class="uicontrol" id="mysql-0078__en-us_topic_0000001839142377_uicontrol189688153618"><b><span id="mysql-0078__en-us_topic_0000001839142377_text148961988368"><strong>Protection</strong></span> &gt; Databases &gt; MySQL/MariaDB/GreatSQL</b></span>.</span></li>
     <li><span>View the details.</span><p></p>
      <ul>
       <li>On the <span class="uicontrol"><b><span><strong>Clusters</strong></span></b></span> tab, view the database cluster information.<p>Information of registered clusters is displayed on the page.</p>
        <div class="p">
         <a href="#mysql-0078__en-us_topic_0000001311094177_table664941173815">Table 1</a> describes the detailed information. 
         <div class="tablenoborder">
          <a name="mysql-0078__en-us_topic_0000001311094177_table664941173815"></a><a name="en-us_topic_0000001311094177_table664941173815"></a>
          <table cellpadding="4" cellspacing="0" summary="" id="mysql-0078__en-us_topic_0000001311094177_table664941173815" frame="border" border="1" rules="all">
           <caption>
            <b>Table 1 </b>Host and cluster information
           </caption>
           <colgroup>
            <col style="width:20.31%">
            <col style="width:79.69000000000001%">
           </colgroup>
           <thead align="left">
            <tr>
             <th align="left" class="cellrowborder" valign="top" width="20.31%" id="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.1"><p>Parameter</p></th>
             <th align="left" class="cellrowborder" valign="top" width="79.69000000000001%" id="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.2"><p>Description</p></th>
            </tr>
           </thead>
           <tbody>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.1 "><p><span><strong>Name</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.2 "><p>Name of a database cluster.</p> <p>If you click the cluster name, all hosts in the current cluster and all authenticated databases in the cluster are displayed.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.1 "><p><span><strong>Type</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.2 "><p>Type of the cluster.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.1 "><p><span><strong>Status</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.2 ">
              <div class="p">
               Status of a host or cluster. 
               <ul id="mysql-0078__en-us_topic_0000001656761205_ul14521181171318">
                <li id="mysql-0078__en-us_topic_0000001656761205_li9581105015279"><span id="mysql-0078__en-us_topic_0000001656761205_text25823502275"><strong>Online</strong></span>: When the host is powered on and ProtectAgent on the host is running properly, <span class="uicontrol" id="mysql-0078__en-us_topic_0000001656761205_uicontrol3582850182714"><b><span id="mysql-0078__en-us_topic_0000001656761205_text1558245042710"><strong>Status</strong></span></b></span> of the host is <span class="uicontrol" id="mysql-0078__en-us_topic_0000001656761205_uicontrol75831350142719"><b><span id="mysql-0078__en-us_topic_0000001656761205_text5582850152711"><strong>Online</strong></span></b></span>.<p id="mysql-0078__en-us_topic_0000001656761205_p11316135152712">If there are online hosts in the cluster, the cluster status is <span class="uicontrol" id="mysql-0078__en-us_topic_0000001656761205_uicontrol163391144818"><b><span id="mysql-0078__en-us_topic_0000001656761205_text8333118485"><strong>Online</strong></span></b></span>.</p></li>
                <li id="mysql-0078__en-us_topic_0000001656761205_li10948352162710"><span id="mysql-0078__en-us_topic_0000001656761205_text59501752132717"><strong>Offline</strong></span>: If the host is shut down or ProtectAgent on the host is faulty, <span class="uicontrol" id="mysql-0078__en-us_topic_0000001656761205_uicontrol1995075262716"><b><span id="mysql-0078__en-us_topic_0000001656761205_text2950152172719"><strong>Status</strong></span></b></span> of the host is <span class="uicontrol" id="mysql-0078__en-us_topic_0000001656761205_uicontrol995015272710"><b><span id="mysql-0078__en-us_topic_0000001656761205_text17950252192714"><strong>Offline</strong></span></b></span>.<p id="mysql-0078__en-us_topic_0000001656761205_p6413253102717">If all hosts in the cluster are offline, the cluster status is <span class="uicontrol" id="mysql-0078__en-us_topic_0000001656761205_uicontrol144615404475"><b><span id="mysql-0078__en-us_topic_0000001656761205_text446124014716"><strong>Offline</strong></span></b></span>.</p></li>
               </ul>
              </div></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.1 ">
              <div class="p">
               <span id="mysql-0078__en-us_topic_0000001792344110_text1045121611529"><strong>Owner</strong></span>
               <div class="note" id="mysql-0078__en-us_topic_0000001792344110_note6159153035311">
                <span class="notetitle"> NOTE: </span>
                <div class="notebody">
                 <p id="mysql-0078__en-us_topic_0000001792344110_p815914301534">This parameter is available only in 1.5.0.</p>
                </div>
               </div>
              </div></td>
             <td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.3.2.2.3.1.2 "><p>Data protection administrator of a host or cluster.</p> <p>If a host or cluster has been authorized to a data protection administrator, the name of the data protection administrator is displayed. If no data protection administrator is authorized, <strong id="mysql-0078__en-us_topic_0000001656761205_b1022551410446">--</strong> is displayed.</p></td>
            </tr>
           </tbody>
          </table>
         </div>
        </div></li>
       <li>On the <span class="uicontrol"><b><span><strong>Instances</strong></span></b></span> tab page, view the database instance information.
        <div class="p">
         <a href="#mysql-0078__table165331245151911">Table 2</a> describes the database instance information. 
         <div class="tablenoborder">
          <a name="mysql-0078__table165331245151911"></a><a name="table165331245151911"></a>
          <table cellpadding="4" cellspacing="0" summary="" id="mysql-0078__table165331245151911" frame="border" border="1" rules="all">
           <caption>
            <b>Table 2 </b>Database instance information
           </caption>
           <colgroup>
            <col style="width:20.330000000000002%">
            <col style="width:79.67%">
           </colgroup>
           <thead align="left">
            <tr>
             <th align="left" class="cellrowborder" valign="top" width="20.330000000000002%" id="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1"><p>Parameter</p></th>
             <th align="left" class="cellrowborder" valign="top" width="79.67%" id="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2"><p>Description</p></th>
            </tr>
           </thead>
           <tbody>
            <tr>
             <td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span><strong>Name</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>Name of a database instance.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span><strong>Status</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>Database instance status.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><strong>Owning Host/Cluster</strong></p></td>
             <td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>Name of the host or cluster where the database instance resides.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span><strong>Database Type</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>Type of the database where the instance is located.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span><strong>Version</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>Version of the database where the instance is located.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span><strong>SLAs</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>If an SLA is associated with the database, the SLA name is displayed. Otherwise, <span class="uicontrol" id="mysql-0078__en-us_topic_0000001656761205_uicontrol4603205811816"><b>--</b></span> is displayed.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span><strong>SLA Compliance</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 ">
              <div class="p">
               Whether a backup job is successfully executed based on the backup interval or backup window set in the SLA.
               <ul id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_ul1823814519293">
                <li id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li9238184572919"><strong id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_b1092516394564">Met</strong>: If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li>
                <li id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li189142052112912"><strong id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_b541520442564">Missed</strong>: If the backup time does not meet the backup time window or backup interval requirements, for example, if the backup interval set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup interval or backup window.</li>
               </ul>
              </div></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 "><p><span><strong>Protection Status</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>Whether the database is protected.</p>
              <ul>
               <li><span><strong>Unprotected</strong></span>: The database is not associated with an SLA, or the database is associated with an SLA but protection is disabled.</li>
               <li><span><strong>Protected</strong></span>: The database is associated with an SLA and protection is activated.</li>
               <li><span><strong>Creating</strong></span>: The database is associated with an SLA and protection is being created.</li>
              </ul></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.1 ">
              <div class="p">
               <strong id="mysql-0078__en-us_topic_0000001792344110_b827118125517">Tag</strong>
               <div class="note" id="mysql-0078__en-us_topic_0000001792344110_note1330311543247">
                <span class="notetitle"> NOTE: </span>
                <div class="notebody">
                 <p id="mysql-0078__en-us_topic_0000001792344110_p630385412417">This parameter is available only in 1.6.0 and later versions.</p>
                </div>
               </div>
              </div></td>
             <td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.2.2.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="mysql-0078__en-us_topic_0000001792344110_b1959642011219">--</strong> is displayed.</p></td>
            </tr>
           </tbody>
          </table>
         </div>
        </div>
        <ol type="a">
         <li>Click the name and check the overview, copy information, and jobs. 
          <ul>
           <li>Overview<p>Displays the SLA information, job execution time, and total number of copies.</p></li>
           <li>Copy data<p>You can search for copies by year, month, and day in sequence.</p> <p>If <span><img src="en-us_image_0000001949081409.png"></span> is displayed below the time, a copy at that time exists.</p></li>
           <li>Job<p>Displays jobs of backup, restoration, and so on.</p></li>
          </ul></li>
        </ol></li>
       <li>On the <span class="uicontrol"><b><span><strong>Databases</strong></span></b></span> tab page, view the database information.<p>The registered databases are displayed on the page.</p>
        <div class="p">
         <a href="#mysql-0078__en-us_topic_0000001311094177_table2382789197">Table 3</a> describes the database information. 
         <div class="tablenoborder">
          <a name="mysql-0078__en-us_topic_0000001311094177_table2382789197"></a><a name="en-us_topic_0000001311094177_table2382789197"></a>
          <table cellpadding="4" cellspacing="0" summary="" id="mysql-0078__en-us_topic_0000001311094177_table2382789197" frame="border" border="1" rules="all">
           <caption>
            <b>Table 3 </b>Database information
           </caption>
           <colgroup>
            <col style="width:20.369999999999997%">
            <col style="width:79.63%">
           </colgroup>
           <thead align="left">
            <tr>
             <th align="left" class="cellrowborder" valign="top" width="20.369999999999997%" id="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1"><p>Parameter</p></th>
             <th align="left" class="cellrowborder" valign="top" width="79.63%" id="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2"><p>Description</p></th>
            </tr>
           </thead>
           <tbody>
            <tr>
             <td class="cellrowborder" valign="top" width="20.369999999999997%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p><span><strong>Name</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.63%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>Database name.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.369999999999997%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p>Owning host/cluster</p></td>
             <td class="cellrowborder" valign="top" width="79.63%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>Name of the host or cluster where the database resides.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.369999999999997%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p>Instance</p></td>
             <td class="cellrowborder" valign="top" width="79.63%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>Name of a database instance.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.369999999999997%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p><span><strong>SLAs</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.63%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>If an SLA is associated with the database, the SLA name is displayed. Otherwise, <span class="uicontrol" id="mysql-0078__en-us_topic_0000001656761205_uicontrol4603205811816_1"><b>--</b></span> is displayed.</p></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.369999999999997%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p><span><strong>SLA Compliance</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.63%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 ">
              <div class="p">
               Whether a backup job is successfully executed based on the backup interval or backup window set in the SLA.
               <ul id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_ul1823814519293_1">
                <li id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li9238184572919_1"><strong id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_b1092516394564_1">Met</strong>: If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li>
                <li id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li189142052112912_1"><strong id="mysql-0078__en-us_topic_0000001792344110_en-us_topic_0000001792344094_b541520442564_1">Missed</strong>: If the backup time does not meet the backup time window or backup interval requirements, for example, if the backup interval set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup interval or backup window.</li>
               </ul>
              </div></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.369999999999997%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p><span><strong>Protection Status</strong></span></p></td>
             <td class="cellrowborder" valign="top" width="79.63%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>Indicates whether the database is protected.</p>
              <ul>
               <li><span><strong>Unprotected</strong></span>: The database is not associated with an SLA, or the database is associated with an SLA but protection is disabled.</li>
               <li><span><strong>Protected</strong></span>: The database is associated with an SLA and protection is activated.</li>
               <li><span><strong>Creating</strong></span>: The database is associated with an SLA and protection is being created.</li>
              </ul></td>
            </tr>
            <tr>
             <td class="cellrowborder" valign="top" width="20.369999999999997%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 ">
              <div class="p">
               <strong id="mysql-0078__en-us_topic_0000001792344110_b827118125517_1">Tag</strong>
               <div class="note" id="mysql-0078__en-us_topic_0000001792344110_note1330311543247_1">
                <span class="notetitle"> NOTE: </span>
                <div class="notebody">
                 <p id="mysql-0078__en-us_topic_0000001792344110_p630385412417_1">This parameter is available only in 1.6.0 and later versions.</p>
                </div>
               </div>
              </div></td>
             <td class="cellrowborder" valign="top" width="79.63%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="mysql-0078__en-us_topic_0000001792344110_b1959642011219_1">--</strong> is displayed.</p></td>
            </tr>
           </tbody>
          </table>
         </div>
        </div>
        <ol type="a">
         <li>Click the name and check the overview, copy information, and jobs. 
          <ul>
           <li>Overview<p>Displays the SLA information, job execution time, and total number of copies.</p></li>
           <li>Copy data<p>You can search for copies by year, month, and day in sequence.</p> <p>If <span><img src="en-us_image_0000001839142729.png"></span> is displayed below the time, a copy at that time exists.</p></li>
           <li>Jobs<p>Displays jobs of backup, restoration, and so on.</p></li>
          </ul></li>
        </ol></li>
      </ul> <p></p></li>
    </ol>
   </div>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>Parent topic:</strong> <a href="mysql-0077.html">MySQL/MariaDB/GreatSQL Database Environment</a>
    </div>
   </div>
  </div>
 </body>
</html>